﻿<%@ Page Title="" Language="C#" MasterPageFile="~/SiteTemplate.Master" AutoEventWireup="true" CodeBehind="SearchCar.aspx.cs" Inherits="carportal.SearchCar" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style type="text/css">
        .style3
        {}
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <table class="style1">
        <tr>
            <td>
                <asp:SqlDataSource ID="SqlDataSourceSearchCar" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:bestgifts4usConnectionString %>" 
                    DeleteCommand="DELETE FROM [carportal_search_cars] WHERE [id] = @id" 
                    InsertCommand="INSERT INTO carportal_search_cars(searched_user, make, model, model_by_user, car_type, engine_power, first_reg_date, millage_km, fuel_type, gearbox, price_from, price_to, country_code, location_city, climate_control, seat_count, color, door_count, Auxiliary_heating, Central_locking, Cruise_control, Electric_heated, Electric_windows, Leather_seats, Parking_sensors, Power_Steering, Sunroof, Four_wheel_drive, Immobilizer, Xenon_headlights, ABS, ESP, user_comments, first_reg_year_from, first_reg_year_to) VALUES (@searched_user, @make, @model, @model_by_user, @car_type, @engine_power, @first_reg_date, @millage_km, @fuel_type, @gearbox, @price_from, @price_to, @country_code, @location_city, @climate_control, @seat_count, @color, @door_count, @Auxiliary_heating, @Central_locking, @Cruise_control, @Electric_heated, @Electric_windows, @Leather_seats, @Parking_sensors, @Power_Steering, @Sunroof, @Four_wheel_drive, @Immobilizer, @Xenon_headlights, @ABS, @ESP, @user_comments, @first_reg_year_from, @first_reg_year_to);
SELECT  @SearchID = SCOPE_IDENTITY();" 
                    SelectCommand="SELECT * FROM [carportal_search_cars]" 
                    
                    
                    UpdateCommand="UPDATE [carportal_search_cars] SET [searched_user] = @searched_user, [make] = @make, [model] = @model, [model_by_user] = @model_by_user, [car_type] = @car_type, [engine_power] = @engine_power, [first_reg_date] = @first_reg_date, [millage_km] = @millage_km, [fuel_type] = @fuel_type, [gearbox] = @gearbox, [price_from] = @price_from, [price_to] = @price_to, [country_code] = @country_code, [location_city] = @location_city, [climate_control] = @climate_control, [seat_count] = @seat_count, [color] = @color, [door_count] = @door_count, [Auxiliary_heating] = @Auxiliary_heating, [Central_locking] = @Central_locking, [Cruise_control] = @Cruise_control, [Electric_heated] = @Electric_heated, [Electric_windows] = @Electric_windows, [Leather_seats] = @Leather_seats, [Parking_sensors] = @Parking_sensors, [Power_Steering] = @Power_Steering, [Sunroof] = @Sunroof, [Four_wheel_drive] = @Four_wheel_drive, [Immobilizer] = @Immobilizer, [Xenon_headlights] = @Xenon_headlights, [ABS] = @ABS, [ESP] = @ESP, [user_comments] = @user_comments WHERE [id] = @id" 
                    oninserted="SqlDataSourceSearchCar_Inserted">
                    <DeleteParameters>
                        <asp:Parameter Name="id" Type="Int32" />
                    </DeleteParameters>
                    <InsertParameters>
                        <asp:Parameter Name="searched_user" Type="Int32" />
                        <asp:Parameter Name="make" Type="Int32" />
                        <asp:Parameter Name="model" Type="Int32" />
                        <asp:Parameter Name="model_by_user" Type="String" />
                        <asp:Parameter Name="car_type" Type="String" />
                        <asp:Parameter Name="engine_power" Type="String" />
                        <asp:Parameter Name="first_reg_date" Type="String" />
                        <asp:Parameter Name="millage_km" Type="String" />
                        <asp:Parameter Name="fuel_type" Type="String" />
                        <asp:Parameter Name="gearbox" Type="String" />
                        <asp:Parameter Name="price_from" Type="Decimal" />
                        <asp:Parameter Name="price_to" Type="Decimal" />
                        <asp:Parameter Name="country_code" Type="String" />
                        <asp:Parameter Name="location_city" Type="String" />
                        <asp:Parameter Name="climate_control" Type="String" />
                        <asp:Parameter Name="seat_count" Type="Int32" />
                        <asp:Parameter Name="color" Type="String" />
                        <asp:Parameter Name="door_count" Type="Int32" />
                        <asp:Parameter Name="Auxiliary_heating" Type="Boolean" />
                        <asp:Parameter Name="Central_locking" Type="Boolean" />
                        <asp:Parameter Name="Cruise_control" Type="Boolean" />
                        <asp:Parameter Name="Electric_heated" Type="Boolean" />
                        <asp:Parameter Name="Electric_windows" Type="Boolean" />
                        <asp:Parameter Name="Leather_seats" Type="Boolean" />
                        <asp:Parameter Name="Parking_sensors" Type="Boolean" />
                        <asp:Parameter Name="Power_Steering" Type="Boolean" />
                        <asp:Parameter Name="Sunroof" Type="Boolean" />
                        <asp:Parameter Name="Four_wheel_drive" Type="Boolean" />
                        <asp:Parameter Name="Immobilizer" Type="Boolean" />
                        <asp:Parameter Name="Xenon_headlights" Type="Boolean" />
                        <asp:Parameter Name="ABS" Type="Boolean" />
                        <asp:Parameter Name="ESP" Type="Boolean" />
                        <asp:Parameter Name="user_comments" Type="String" />
                        <asp:Parameter Name="first_reg_year_from" />
                        <asp:Parameter Name="first_reg_year_to" />
                        <asp:Parameter Name="SearchID"  Direction="Output" Type="Int32"  />
                    </InsertParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="searched_user" Type="Int32" />
                        <asp:Parameter Name="make" Type="Int32" />
                        <asp:Parameter Name="model" Type="Int32" />
                        <asp:Parameter Name="model_by_user" Type="String" />
                        <asp:Parameter Name="car_type" Type="String" />
                        <asp:Parameter Name="engine_power" Type="String" />
                        <asp:Parameter Name="first_reg_date" Type="String" />
                        <asp:Parameter Name="millage_km" Type="String" />
                        <asp:Parameter Name="fuel_type" Type="String" />
                        <asp:Parameter Name="gearbox" Type="String" />
                        <asp:Parameter Name="price_from" Type="Decimal" />
                        <asp:Parameter Name="price_to" Type="Decimal" />
                        <asp:Parameter Name="country_code" Type="String" />
                        <asp:Parameter Name="location_city" Type="String" />
                        <asp:Parameter Name="climate_control" Type="String" />
                        <asp:Parameter Name="seat_count" Type="Int32" />
                        <asp:Parameter Name="color" Type="String" />
                        <asp:Parameter Name="door_count" Type="Int32" />
                        <asp:Parameter Name="Auxiliary_heating" Type="Boolean" />
                        <asp:Parameter Name="Central_locking" Type="Boolean" />
                        <asp:Parameter Name="Cruise_control" Type="Boolean" />
                        <asp:Parameter Name="Electric_heated" Type="Boolean" />
                        <asp:Parameter Name="Electric_windows" Type="Boolean" />
                        <asp:Parameter Name="Leather_seats" Type="Boolean" />
                        <asp:Parameter Name="Parking_sensors" Type="Boolean" />
                        <asp:Parameter Name="Power_Steering" Type="Boolean" />
                        <asp:Parameter Name="Sunroof" Type="Boolean" />
                        <asp:Parameter Name="Four_wheel_drive" Type="Boolean" />
                        <asp:Parameter Name="Immobilizer" Type="Boolean" />
                        <asp:Parameter Name="Xenon_headlights" Type="Boolean" />
                        <asp:Parameter Name="ABS" Type="Boolean" />
                        <asp:Parameter Name="ESP" Type="Boolean" />
                        <asp:Parameter Name="user_comments" Type="String" />
                        <asp:Parameter Name="id" Type="Int32" />
                    </UpdateParameters>
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:bestgifts4usConnectionString %>" 
                    SelectCommand="SELECT [vehicletype], [id] FROM [carportal_vehicletypes]">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="SqlDataSourceCounties" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:bestgifts4usConnectionString %>" 
                    
                    SelectCommand="SELECT [id], [countrycode], [countryname] FROM [carportal_countries]">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="SqlDataSourceMakes" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:bestgifts4usConnectionString %>" 
                    SelectCommand="SELECT [id], [make_name] FROM [carportal_make]">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="SqlDataSourceModel" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:bestgifts4usConnectionString %>" 
                    SelectCommand="SELECT [id], [model], [make_id] FROM [carportal_model]">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="SqlDataSourceSearch_result" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:bestgifts4usConnectionString %>" 
                    SelectCommand="SELECT carportal_cars.id, carportal_cars.user_id, carportal_cars.make, carportal_cars.model, carportal_cars.model_by_user, carportal_cars.car_type, carportal_cars.engine_power, carportal_cars.first_reg_date, carportal_cars.millage_km, carportal_cars.fuel_type, carportal_cars.gearbox, carportal_cars.price, carportal_cars.country_code, carportal_cars.location_city, carportal_cars.climate_control, carportal_cars.seat_count, carportal_cars.color, carportal_cars.door_count, carportal_cars.Auxiliary_heating, carportal_cars.Central_locking, carportal_cars.Cruise_control, carportal_cars.Electric_heated, carportal_cars.Electric_windows, carportal_cars.Leather_seats, carportal_cars.Parking_sensors, carportal_cars.Power_Steering, carportal_cars.Sunroof, carportal_cars.Four_wheel_drive, carportal_cars.Immobilizer, carportal_cars.Xenon_headlights, carportal_cars.ABS, carportal_cars.ESP, carportal_cars.user_comments, carportal_make.id AS Expr1, carportal_make.make_name, carportal_model.id AS Expr2, carportal_model.make_id, carportal_countries.id AS Expr4, carportal_countries.countrycode, carportal_countries.countryname, carportal_vehicletypes.id AS Expr5, carportal_vehicletypes.vehicletype, carportal_search_cars.id AS Expr6, carportal_search_cars.searched_user, carportal_search_cars.make AS Expr7, carportal_search_cars.model AS Expr8, carportal_search_cars.model_by_user AS Expr9, carportal_search_cars.car_type AS Expr10, carportal_search_cars.engine_power AS Expr11, carportal_search_cars.first_reg_date AS Expr12, carportal_search_cars.millage_km AS Expr13, carportal_search_cars.fuel_type AS Expr14, carportal_search_cars.gearbox AS Expr15, carportal_search_cars.price_from, carportal_search_cars.price_to, carportal_search_cars.country_code AS Expr16, carportal_search_cars.location_city AS Expr17, carportal_search_cars.climate_control AS Expr18, carportal_search_cars.seat_count AS Expr19, carportal_search_cars.color AS Expr20, carportal_search_cars.door_count AS Expr21, carportal_search_cars.Auxiliary_heating AS Expr22, carportal_search_cars.Central_locking AS Expr23, carportal_search_cars.Cruise_control AS Expr24, carportal_search_cars.Electric_heated AS Expr25, carportal_search_cars.Electric_windows AS Expr26, carportal_search_cars.Leather_seats AS Expr27, carportal_search_cars.Parking_sensors AS Expr28, carportal_search_cars.Power_Steering AS Expr29, carportal_search_cars.Sunroof AS Expr30, carportal_search_cars.Four_wheel_drive AS Expr31, carportal_search_cars.Immobilizer AS Expr32, carportal_search_cars.Xenon_headlights AS Expr33, carportal_search_cars.ABS AS Expr34, carportal_search_cars.ESP AS Expr35, carportal_search_cars.user_comments AS Expr36, carportal_search_cars.first_reg_year_from, carportal_search_cars.first_reg_year_to, carportal_model.model AS modelname FROM carportal_cars INNER JOIN carportal_make ON carportal_cars.make = carportal_make.id INNER JOIN carportal_model ON carportal_cars.model = carportal_model.id INNER JOIN carportal_countries ON carportal_cars.country_code = carportal_countries.id INNER JOIN carportal_vehicletypes ON carportal_cars.car_type = carportal_vehicletypes.id INNER JOIN carportal_search_cars ON 1 = 1 AND (carportal_cars.make = carportal_search_cars.make OR carportal_search_cars.make = - 1) AND (carportal_cars.model = carportal_search_cars.model OR carportal_search_cars.model = - 1) AND (carportal_cars.car_type = carportal_search_cars.car_type OR carportal_search_cars.car_type = - 1) AND (carportal_cars.gearbox = carportal_search_cars.gearbox OR carportal_search_cars.gearbox = '-1') AND carportal_cars.price BETWEEN carportal_search_cars.price_from AND carportal_search_cars.price_to AND carportal_cars.first_reg_date BETWEEN carportal_search_cars.first_reg_year_from AND carportal_search_cars.first_reg_year_to WHERE (carportal_search_cars.id = @searchid)">
                    <SelectParameters>
                        <asp:SessionParameter Name="searchid" SessionField="SearchID" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:FormView ID="FormView1" runat="server" CssClass="style3" DataKeyNames="id" 
                    DataSourceID="SqlDataSourceSearchCar" DefaultMode="Insert" Width="526px" 
                    oniteminserted="FormView1_ItemInserted" AllowPaging="True">
                     
                    <InsertItemTemplate>
                        <br />
                        <table class="style1">
                            <tr>
                                <td>
                                    Make:
                                    <asp:DropDownList ID="DropDownList2" runat="server" AppendDataBoundItems="True" 
                                        DataSourceID="SqlDataSourceMakes" DataTextField="make_name" DataValueField="id" 
                                        SelectedValue='<%# Bind("make") %>'>
                                        <asp:ListItem Value="-1">Any</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Model:
                                    <asp:DropDownList ID="DropDownList3" runat="server" AppendDataBoundItems="True" 
                                        DataSourceID="SqlDataSourceModel" DataTextField="model" DataValueField="id" 
                                        SelectedValue='<%# Bind("model") %>'>
                                        <asp:ListItem Value="-1">Any</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Type:
                                    <asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="True" 
                                        DataSourceID="SqlDataSource1" DataTextField="vehicletype" DataValueField="id" 
                                        SelectedValue='<%# Bind("car_type") %>'>
                                        <asp:ListItem Value="-1">Any</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Gearbox:
                                    <asp:DropDownList ID="DropDownListClima" runat="server" 
                                        meta:resourcekey="DropDownList8Resource1" 
                                        SelectedValue='<%# Bind("gearbox") %>'>
                                        <asp:ListItem meta:resourcekey="ListItemResource30" Value="-1">Does not metter</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource31" Value="Automatic">Automatic</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource32" Value="Manual">Manual</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Price From:<asp:DropDownList ID="DropDownList5" runat="server" Height="20px" 
                                        SelectedValue='<%# Bind("price_from") %>' Width="79px">
                                        <asp:ListItem>300</asp:ListItem>
                                        <asp:ListItem>400</asp:ListItem>
                                        <asp:ListItem>500</asp:ListItem>
                                        <asp:ListItem>600</asp:ListItem>
                                        <asp:ListItem>700</asp:ListItem>
                                        <asp:ListItem>800</asp:ListItem>
                                        <asp:ListItem>900</asp:ListItem>
                                        <asp:ListItem>1000</asp:ListItem>
                                        <asp:ListItem>1100</asp:ListItem>
                                        <asp:ListItem>1200</asp:ListItem>
                                        <asp:ListItem>1300</asp:ListItem>
                                        <asp:ListItem>1400</asp:ListItem>
                                        <asp:ListItem>1500</asp:ListItem>
                                        <asp:ListItem>1600</asp:ListItem>
                                        <asp:ListItem>1700</asp:ListItem>
                                        <asp:ListItem>1800</asp:ListItem>
                                        <asp:ListItem>1900</asp:ListItem>
                                        <asp:ListItem>2000</asp:ListItem>
                                        <asp:ListItem>2500</asp:ListItem>
                                        <asp:ListItem>3000</asp:ListItem>
                                        <asp:ListItem>3500</asp:ListItem>
                                        <asp:ListItem>4000</asp:ListItem>
                                        <asp:ListItem>4500</asp:ListItem>
                                        <asp:ListItem>5000</asp:ListItem>
                                        <asp:ListItem>5500</asp:ListItem>
                                        <asp:ListItem>6000</asp:ListItem>
                                        <asp:ListItem>6500</asp:ListItem>
                                        <asp:ListItem>7000</asp:ListItem>
                                        <asp:ListItem>7500</asp:ListItem>
                                        <asp:ListItem>8000</asp:ListItem>
                                        <asp:ListItem>8500</asp:ListItem>
                                        <asp:ListItem>9000</asp:ListItem>
                                        <asp:ListItem>9500</asp:ListItem>
                                        <asp:ListItem>10000</asp:ListItem>
                                        <asp:ListItem>10500</asp:ListItem>
                                        <asp:ListItem>11000</asp:ListItem>
                                        <asp:ListItem>11500</asp:ListItem>
                                        <asp:ListItem>12000</asp:ListItem>
                                        <asp:ListItem>12500</asp:ListItem>
                                        <asp:ListItem>13000</asp:ListItem>
                                        <asp:ListItem>13500</asp:ListItem>
                                        <asp:ListItem>14000</asp:ListItem>
                                        <asp:ListItem>14500</asp:ListItem>
                                        <asp:ListItem>15000</asp:ListItem>
                                        <asp:ListItem>15500</asp:ListItem>
                                        <asp:ListItem>16000</asp:ListItem>
                                        <asp:ListItem>16500</asp:ListItem>
                                        <asp:ListItem>17000</asp:ListItem>
                                        <asp:ListItem>17500</asp:ListItem>
                                        <asp:ListItem>18000</asp:ListItem>
                                        <asp:ListItem>18500</asp:ListItem>
                                        <asp:ListItem>19000</asp:ListItem>
                                        <asp:ListItem>19500</asp:ListItem>
                                        <asp:ListItem>20000</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Price To:<asp:DropDownList ID="DropDownList6" runat="server" 
                                        SelectedValue='<%# Bind("price_to") %>'>
                                        <asp:ListItem>300</asp:ListItem>
                                        <asp:ListItem>400</asp:ListItem>
                                        <asp:ListItem>500</asp:ListItem>
                                        <asp:ListItem>600</asp:ListItem>
                                        <asp:ListItem>700</asp:ListItem>
                                        <asp:ListItem>800</asp:ListItem>
                                        <asp:ListItem>900</asp:ListItem>
                                        <asp:ListItem>1000</asp:ListItem>
                                        <asp:ListItem>1100</asp:ListItem>
                                        <asp:ListItem>1200</asp:ListItem>
                                        <asp:ListItem>1300</asp:ListItem>
                                        <asp:ListItem>1400</asp:ListItem>
                                        <asp:ListItem>1500</asp:ListItem>
                                        <asp:ListItem>1600</asp:ListItem>
                                        <asp:ListItem>1700</asp:ListItem>
                                        <asp:ListItem>1800</asp:ListItem>
                                        <asp:ListItem>1900</asp:ListItem>
                                        <asp:ListItem>2000</asp:ListItem>
                                        <asp:ListItem>2500</asp:ListItem>
                                        <asp:ListItem>3000</asp:ListItem>
                                        <asp:ListItem>3500</asp:ListItem>
                                        <asp:ListItem>4000</asp:ListItem>
                                        <asp:ListItem>4500</asp:ListItem>
                                        <asp:ListItem>5000</asp:ListItem>
                                        <asp:ListItem>5500</asp:ListItem>
                                        <asp:ListItem>6000</asp:ListItem>
                                        <asp:ListItem>6500</asp:ListItem>
                                        <asp:ListItem>7000</asp:ListItem>
                                        <asp:ListItem>7500</asp:ListItem>
                                        <asp:ListItem>8000</asp:ListItem>
                                        <asp:ListItem>8500</asp:ListItem>
                                        <asp:ListItem>9000</asp:ListItem>
                                        <asp:ListItem>9500</asp:ListItem>
                                        <asp:ListItem Selected="True">10000</asp:ListItem>
                                        <asp:ListItem>10500</asp:ListItem>
                                        <asp:ListItem>11000</asp:ListItem>
                                        <asp:ListItem>11500</asp:ListItem>
                                        <asp:ListItem>12000</asp:ListItem>
                                        <asp:ListItem>12500</asp:ListItem>
                                        <asp:ListItem>13000</asp:ListItem>
                                        <asp:ListItem>13500</asp:ListItem>
                                        <asp:ListItem>14000</asp:ListItem>
                                        <asp:ListItem>14500</asp:ListItem>
                                        <asp:ListItem>15000</asp:ListItem>
                                        <asp:ListItem>15500</asp:ListItem>
                                        <asp:ListItem>16000</asp:ListItem>
                                        <asp:ListItem>16500</asp:ListItem>
                                        <asp:ListItem>17000</asp:ListItem>
                                        <asp:ListItem>17500</asp:ListItem>
                                        <asp:ListItem>18000</asp:ListItem>
                                        <asp:ListItem>18500</asp:ListItem>
                                        <asp:ListItem>19000</asp:ListItem>
                                        <asp:ListItem>19500</asp:ListItem>
                                        <asp:ListItem>20000</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Firest reg from:<asp:DropDownList ID="DropDownList8" runat="server" 
                                        SelectedValue='<%# Bind("first_reg_year_from") %>'>
                                        <asp:ListItem meta:resourcekey="ListItemResource1">2012</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource2">2011</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource3">2010</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource4">2009</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource5">2008</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource6">2007</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource7">2006</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource8">2005</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource9">2004</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource10">2003</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource11">2002</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource12">2001</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource13" Selected="True">2000</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Firest reg to:<asp:DropDownList ID="DropDownList9" runat="server" 
                                        SelectedValue='<%# Bind("first_reg_year_to") %>'>
                                        <asp:ListItem meta:resourcekey="ListItemResource1">2012</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource2">2011</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource3">2010</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource4">2009</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource5">2008</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource6">2007</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource7">2006</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource8">2005</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource9">2004</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource10">2003</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource11">2002</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource12">2001</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource13">2000</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    <br />
                                    Color:
                                    <asp:DropDownList ID="DropDownListColor" runat="server" 
                                        meta:resourcekey="DropDownList11Resource1" SelectedValue='<%# Bind("color") %>'>
                                        <asp:ListItem Value="-1">Does not metter</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource45">Beige</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource46">Black</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource47">Blue</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource48">Brown</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource49">Gold</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource50">Green</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource51">Grey</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource52">Orange</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource53">Purple</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource54">Red</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource55">Silver</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource56">White</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource57">Yellow</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource58">Other</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Doors:
                                    <asp:DropDownList ID="DropDownListSeatcount" runat="server" 
                                        meta:resourcekey="DropDownList9Resource1" 
                                        SelectedValue='<%# Bind("door_count") %>'>
                                        <asp:ListItem Value="-1">Any</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource33">2</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource34">4</asp:ListItem>
                                        <asp:ListItem>5</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource35">6</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource36">7</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource37">8</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource38">More</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Sears:
                                    <asp:DropDownList ID="DropDownListDorrCount" runat="server" 
                                        meta:resourcekey="DropDownList10Resource1" 
                                        SelectedValue='<%# Bind("seat_count") %>'>
                                        <asp:ListItem Value="-1">Any</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource39">2</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource40">3</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource41">4</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource42">5</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource43">6</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource44">7</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Location:
                                    <asp:DropDownList ID="DropDownList7" runat="server" AppendDataBoundItems="True" 
                                        DataSourceID="SqlDataSourceCounties" DataTextField="countryname" 
                                        DataValueField="id" oninit="DropDownList7_Init" 
                                        SelectedValue='<%# Bind("country_code") %>'>
                                    </asp:DropDownList>
                                    <br />
                                    Clima:
                                    <asp:DropDownList ID="DropDownListClima0" runat="server" 
                                        meta:resourcekey="DropDownList8Resource1" 
                                        SelectedValue='<%# Bind("climate_control") %>'>
                                        <asp:ListItem meta:resourcekey="ListItemResource30" Value="0">No</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource31" Value="1">Automatic</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource32" Value="1">Manual</asp:ListItem>
                                    </asp:DropDownList>
                                </td>
                                <td>
                                    Auxiliary_heating:
                                    <asp:CheckBox ID="Auxiliary_heatingCheckBox" runat="server" 
                                        Checked='<%# Bind("Auxiliary_heating") %>' />
                                    <br />
                                    Central_locking:
                                    <asp:CheckBox ID="Central_lockingCheckBox" runat="server" 
                                        Checked='<%# Bind("Central_locking") %>' />
                                    <br />
                                    Cruise_control:
                                    <asp:CheckBox ID="Cruise_controlCheckBox" runat="server" 
                                        Checked='<%# Bind("Cruise_control") %>' />
                                    <br />
                                    Electric_heated:
                                    <asp:CheckBox ID="Electric_heatedCheckBox" runat="server" 
                                        Checked='<%# Bind("Electric_heated") %>' />
                                    <br />
                                    Electric_windows:
                                    <asp:CheckBox ID="Electric_windowsCheckBox" runat="server" 
                                        Checked='<%# Bind("Electric_windows") %>' />
                                    <br />
                                    Leather_seats:
                                    <asp:CheckBox ID="Leather_seatsCheckBox" runat="server" 
                                        Checked='<%# Bind("Leather_seats") %>' />
                                    <br />
                                    Parking_sensors:
                                    <asp:CheckBox ID="Parking_sensorsCheckBox" runat="server" 
                                        Checked='<%# Bind("Parking_sensors") %>' />
                                    <br />
                                    Power_Steering:
                                    <asp:CheckBox ID="Power_SteeringCheckBox" runat="server" 
                                        Checked='<%# Bind("Power_Steering") %>' />
                                    <br />
                                    Sunroof:
                                    <asp:CheckBox ID="SunroofCheckBox" runat="server" 
                                        Checked='<%# Bind("Sunroof") %>' />
                                    <br />
                                    Four_wheel_drive:
                                    <asp:CheckBox ID="Four_wheel_driveCheckBox" runat="server" 
                                        Checked='<%# Bind("Four_wheel_drive") %>' />
                                    <br />
                                    Immobilizer:
                                    <asp:CheckBox ID="ImmobilizerCheckBox" runat="server" 
                                        Checked='<%# Bind("Immobilizer") %>' />
                                    <br />
                                    Xenon_headlights:
                                    <asp:CheckBox ID="Xenon_headlightsCheckBox" runat="server" 
                                        Checked='<%# Bind("Xenon_headlights") %>' />
                                    <br />
                                    ABS:
                                    <asp:CheckBox ID="ABSCheckBox" runat="server" Checked='<%# Bind("ABS") %>' />
                                    <br />
                                    ESP:
                                    <asp:CheckBox ID="ESPCheckBox" runat="server" Checked='<%# Bind("ESP") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    &nbsp;</td>
                                <td>
                                    &nbsp;</td>
                            </tr>
                        </table>
                        <br />
                        <br />
                        searched_user:
                        <asp:TextBox ID="searched_userTextBox" runat="server" 
                            Text='<%# Bind("searched_user") %>' />
                        <br />
                        model_by_user:
                        <asp:TextBox ID="model_by_userTextBox" runat="server" 
                            Text='<%# Bind("model_by_user") %>' />
                        <br />
                        <br />
                        engine_power:
                        <asp:TextBox ID="engine_powerTextBox" runat="server" 
                            Text='<%# Bind("engine_power") %>' />
                        <br />
                        first_reg_date:
                        <asp:TextBox ID="first_reg_dateTextBox" runat="server" 
                            Text='<%# Bind("first_reg_date") %>' />
                        <br />
                        millage_km:
                        <asp:TextBox ID="millage_kmTextBox" runat="server" 
                            Text='<%# Bind("millage_km") %>' />
                        <br />
                        fuel_type: <br />
                        gearbox: <br />
                        <br />
                        country_code:
                        <asp:TextBox ID="country_codeTextBox" runat="server" 
                            Text='<%# Bind("country_code") %>' />
                        <br />
                        location_city: <br />
                        climate_control:
                        <asp:TextBox ID="climate_controlTextBox" runat="server" 
                            Text='<%# Bind("climate_control") %>' />
                        <br />
                        seat_count: <br />
                        color: <br />
                        door_count: <br />
                        <br />
                        user_comments:
                        <asp:TextBox ID="user_commentsTextBox" runat="server" 
                            Text='<%# Bind("user_comments") %>' />
                        <br />
                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 
                            CommandName="Insert" Text="Insert" />
                        &nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server" 
                            CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                    </InsertItemTemplate>
                     <EditItemTemplate>
                        <br />
                        <table class="style1">
                            <tr>
                                <td>
                                    Make:
                                    <asp:DropDownList ID="DropDownList2" runat="server" AppendDataBoundItems="True" 
                                        DataSourceID="SqlDataSourceMakes" DataTextField="make_name" DataValueField="id" 
                                        SelectedValue='<%# Bind("make") %>'>
                                        <asp:ListItem Value="-1">Any</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Model:
                                    <asp:DropDownList ID="DropDownList3" runat="server" AppendDataBoundItems="True" 
                                        DataSourceID="SqlDataSourceModel" DataTextField="model" DataValueField="id" 
                                         >
                                        
                                    </asp:DropDownList>
                                    <br />
                                    Type:
                                    <asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="True" 
                                        DataSourceID="SqlDataSource1" DataTextField="vehicletype" DataValueField="id" 
                                        SelectedValue='<%# Bind("car_type") %>'>
                                        <asp:ListItem Value="-1">Any</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Gearbox:
                                    <asp:DropDownList ID="DropDownListClima" runat="server" 
                                        meta:resourcekey="DropDownList8Resource1" 
                                        SelectedValue='<%# Bind("gearbox") %>'>
                                        <asp:ListItem meta:resourcekey="ListItemResource30" Value="-1">Does not metter</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource31" Value="Automatic">Automatic</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource32" Value="Manual">Manual</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Price From:<asp:DropDownList ID="DropDownList5" runat="server" Height="20px" 
                                        SelectedValue='<%# Bind("price_from") %>' Width="79px">
                                        <asp:ListItem>300</asp:ListItem>
                                        <asp:ListItem>400</asp:ListItem>
                                        <asp:ListItem>500</asp:ListItem>
                                        <asp:ListItem>600</asp:ListItem>
                                        <asp:ListItem>700</asp:ListItem>
                                        <asp:ListItem>800</asp:ListItem>
                                        <asp:ListItem>900</asp:ListItem>
                                        <asp:ListItem>1000</asp:ListItem>
                                        <asp:ListItem>1100</asp:ListItem>
                                        <asp:ListItem>1200</asp:ListItem>
                                        <asp:ListItem>1300</asp:ListItem>
                                        <asp:ListItem>1400</asp:ListItem>
                                        <asp:ListItem>1500</asp:ListItem>
                                        <asp:ListItem>1600</asp:ListItem>
                                        <asp:ListItem>1700</asp:ListItem>
                                        <asp:ListItem>1800</asp:ListItem>
                                        <asp:ListItem>1900</asp:ListItem>
                                        <asp:ListItem>2000</asp:ListItem>
                                        <asp:ListItem>2500</asp:ListItem>
                                        <asp:ListItem>3000</asp:ListItem>
                                        <asp:ListItem>3500</asp:ListItem>
                                        <asp:ListItem>4000</asp:ListItem>
                                        <asp:ListItem>4500</asp:ListItem>
                                        <asp:ListItem>5000</asp:ListItem>
                                        <asp:ListItem>5500</asp:ListItem>
                                        <asp:ListItem>6000</asp:ListItem>
                                        <asp:ListItem>6500</asp:ListItem>
                                        <asp:ListItem>7000</asp:ListItem>
                                        <asp:ListItem>7500</asp:ListItem>
                                        <asp:ListItem>8000</asp:ListItem>
                                        <asp:ListItem>8500</asp:ListItem>
                                        <asp:ListItem>9000</asp:ListItem>
                                        <asp:ListItem>9500</asp:ListItem>
                                        <asp:ListItem>10000</asp:ListItem>
                                        <asp:ListItem>10500</asp:ListItem>
                                        <asp:ListItem>11000</asp:ListItem>
                                        <asp:ListItem>11500</asp:ListItem>
                                        <asp:ListItem>12000</asp:ListItem>
                                        <asp:ListItem>12500</asp:ListItem>
                                        <asp:ListItem>13000</asp:ListItem>
                                        <asp:ListItem>13500</asp:ListItem>
                                        <asp:ListItem>14000</asp:ListItem>
                                        <asp:ListItem>14500</asp:ListItem>
                                        <asp:ListItem>15000</asp:ListItem>
                                        <asp:ListItem>15500</asp:ListItem>
                                        <asp:ListItem>16000</asp:ListItem>
                                        <asp:ListItem>16500</asp:ListItem>
                                        <asp:ListItem>17000</asp:ListItem>
                                        <asp:ListItem>17500</asp:ListItem>
                                        <asp:ListItem>18000</asp:ListItem>
                                        <asp:ListItem>18500</asp:ListItem>
                                        <asp:ListItem>19000</asp:ListItem>
                                        <asp:ListItem>19500</asp:ListItem>
                                        <asp:ListItem>20000</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Price To:<asp:DropDownList ID="DropDownList6" runat="server" 
                                        SelectedValue='<%# Bind("price_to") %>'>
                                        <asp:ListItem>300</asp:ListItem>
                                        <asp:ListItem>400</asp:ListItem>
                                        <asp:ListItem>500</asp:ListItem>
                                        <asp:ListItem>600</asp:ListItem>
                                        <asp:ListItem>700</asp:ListItem>
                                        <asp:ListItem>800</asp:ListItem>
                                        <asp:ListItem>900</asp:ListItem>
                                        <asp:ListItem>1000</asp:ListItem>
                                        <asp:ListItem>1100</asp:ListItem>
                                        <asp:ListItem>1200</asp:ListItem>
                                        <asp:ListItem>1300</asp:ListItem>
                                        <asp:ListItem>1400</asp:ListItem>
                                        <asp:ListItem>1500</asp:ListItem>
                                        <asp:ListItem>1600</asp:ListItem>
                                        <asp:ListItem>1700</asp:ListItem>
                                        <asp:ListItem>1800</asp:ListItem>
                                        <asp:ListItem>1900</asp:ListItem>
                                        <asp:ListItem>2000</asp:ListItem>
                                        <asp:ListItem>2500</asp:ListItem>
                                        <asp:ListItem>3000</asp:ListItem>
                                        <asp:ListItem>3500</asp:ListItem>
                                        <asp:ListItem>4000</asp:ListItem>
                                        <asp:ListItem>4500</asp:ListItem>
                                        <asp:ListItem>5000</asp:ListItem>
                                        <asp:ListItem>5500</asp:ListItem>
                                        <asp:ListItem>6000</asp:ListItem>
                                        <asp:ListItem>6500</asp:ListItem>
                                        <asp:ListItem>7000</asp:ListItem>
                                        <asp:ListItem>7500</asp:ListItem>
                                        <asp:ListItem>8000</asp:ListItem>
                                        <asp:ListItem>8500</asp:ListItem>
                                        <asp:ListItem>9000</asp:ListItem>
                                        <asp:ListItem>9500</asp:ListItem>
                                        <asp:ListItem Selected="True">10000</asp:ListItem>
                                        <asp:ListItem>10500</asp:ListItem>
                                        <asp:ListItem>11000</asp:ListItem>
                                        <asp:ListItem>11500</asp:ListItem>
                                        <asp:ListItem>12000</asp:ListItem>
                                        <asp:ListItem>12500</asp:ListItem>
                                        <asp:ListItem>13000</asp:ListItem>
                                        <asp:ListItem>13500</asp:ListItem>
                                        <asp:ListItem>14000</asp:ListItem>
                                        <asp:ListItem>14500</asp:ListItem>
                                        <asp:ListItem>15000</asp:ListItem>
                                        <asp:ListItem>15500</asp:ListItem>
                                        <asp:ListItem>16000</asp:ListItem>
                                        <asp:ListItem>16500</asp:ListItem>
                                        <asp:ListItem>17000</asp:ListItem>
                                        <asp:ListItem>17500</asp:ListItem>
                                        <asp:ListItem>18000</asp:ListItem>
                                        <asp:ListItem>18500</asp:ListItem>
                                        <asp:ListItem>19000</asp:ListItem>
                                        <asp:ListItem>19500</asp:ListItem>
                                        <asp:ListItem>20000</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Firest reg from:<asp:DropDownList ID="DropDownList8" runat="server" 
                                        SelectedValue='<%# Bind("first_reg_year_from") %>'>
                                        <asp:ListItem meta:resourcekey="ListItemResource1">2012</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource2">2011</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource3">2010</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource4">2009</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource5">2008</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource6">2007</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource7">2006</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource8">2005</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource9">2004</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource10">2003</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource11">2002</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource12">2001</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource13" Selected="True">2000</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Firest reg to:<asp:DropDownList ID="DropDownList9" runat="server" 
                                        SelectedValue='<%# Bind("first_reg_year_to") %>'>
                                        <asp:ListItem meta:resourcekey="ListItemResource1">2012</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource2">2011</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource3">2010</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource4">2009</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource5">2008</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource6">2007</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource7">2006</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource8">2005</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource9">2004</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource10">2003</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource11">2002</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource12">2001</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource13">2000</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    <br />
                                    Color:
                                    <asp:DropDownList ID="DropDownListColor" runat="server" 
                                        meta:resourcekey="DropDownList11Resource1" SelectedValue='<%# Bind("color") %>'>
                                        <asp:ListItem Value="-1">Does not metter</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource45">Beige</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource46">Black</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource47">Blue</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource48">Brown</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource49">Gold</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource50">Green</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource51">Grey</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource52">Orange</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource53">Purple</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource54">Red</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource55">Silver</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource56">White</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource57">Yellow</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource58">Other</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Doors:
                                    <asp:DropDownList ID="DropDownListSeatcount" runat="server" 
                                        meta:resourcekey="DropDownList9Resource1" 
                                        SelectedValue='<%# Bind("door_count") %>'>
                                        <asp:ListItem Value="-1">Any</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource33">2</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource34">4</asp:ListItem>
                                        <asp:ListItem>5</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource35">6</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource36">7</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource37">8</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource38">More</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Sears:
                                    <asp:DropDownList ID="DropDownListDorrCount" runat="server" 
                                        meta:resourcekey="DropDownList10Resource1" 
                                        SelectedValue='<%# Bind("seat_count") %>'>
                                        <asp:ListItem Value="-1">Any</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource39">2</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource40">3</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource41">4</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource42">5</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource43">6</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource44">7</asp:ListItem>
                                    </asp:DropDownList>
                                    <br />
                                    Location:
                                    <asp:DropDownList ID="DropDownList7" runat="server" AppendDataBoundItems="True" 
                                        DataSourceID="SqlDataSourceCounties" DataTextField="countryname" 
                                        DataValueField="id" oninit="DropDownList7_Init" 
                                        SelectedValue='<%# Bind("country_code") %>'>
                                    </asp:DropDownList>
                                    <br />
                                    Clima:
                                    <asp:DropDownList ID="DropDownListClima0" runat="server" 
                                        meta:resourcekey="DropDownList8Resource1" 
                                        SelectedValue='<%# Bind("climate_control") %>'>
                                        <asp:ListItem meta:resourcekey="ListItemResource30" Value="0">No</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource31" Value="1">Automatic</asp:ListItem>
                                        <asp:ListItem meta:resourcekey="ListItemResource32" Value="1">Manual</asp:ListItem>
                                    </asp:DropDownList>
                                </td>
                                <td>
                                    Auxiliary_heating:
                                    <asp:CheckBox ID="Auxiliary_heatingCheckBox" runat="server" 
                                        Checked='<%# Bind("Auxiliary_heating") %>' />
                                    <br />
                                    Central_locking:
                                    <asp:CheckBox ID="Central_lockingCheckBox" runat="server" 
                                        Checked='<%# Bind("Central_locking") %>' />
                                    <br />
                                    Cruise_control:
                                    <asp:CheckBox ID="Cruise_controlCheckBox" runat="server" 
                                        Checked='<%# Bind("Cruise_control") %>' />
                                    <br />
                                    Electric_heated:
                                    <asp:CheckBox ID="Electric_heatedCheckBox" runat="server" 
                                        Checked='<%# Bind("Electric_heated") %>' />
                                    <br />
                                    Electric_windows:
                                    <asp:CheckBox ID="Electric_windowsCheckBox" runat="server" 
                                        Checked='<%# Bind("Electric_windows") %>' />
                                    <br />
                                    Leather_seats:
                                    <asp:CheckBox ID="Leather_seatsCheckBox" runat="server" 
                                        Checked='<%# Bind("Leather_seats") %>' />
                                    <br />
                                    Parking_sensors:
                                    <asp:CheckBox ID="Parking_sensorsCheckBox" runat="server" 
                                        Checked='<%# Bind("Parking_sensors") %>' />
                                    <br />
                                    Power_Steering:
                                    <asp:CheckBox ID="Power_SteeringCheckBox" runat="server" 
                                        Checked='<%# Bind("Power_Steering") %>' />
                                    <br />
                                    Sunroof:
                                    <asp:CheckBox ID="SunroofCheckBox" runat="server" 
                                        Checked='<%# Bind("Sunroof") %>' />
                                    <br />
                                    Four_wheel_drive:
                                    <asp:CheckBox ID="Four_wheel_driveCheckBox" runat="server" 
                                        Checked='<%# Bind("Four_wheel_drive") %>' />
                                    <br />
                                    Immobilizer:
                                    <asp:CheckBox ID="ImmobilizerCheckBox" runat="server" 
                                        Checked='<%# Bind("Immobilizer") %>' />
                                    <br />
                                    Xenon_headlights:
                                    <asp:CheckBox ID="Xenon_headlightsCheckBox" runat="server" 
                                        Checked='<%# Bind("Xenon_headlights") %>' />
                                    <br />
                                    ABS:
                                    <asp:CheckBox ID="ABSCheckBox" runat="server" Checked='<%# Bind("ABS") %>' />
                                    <br />
                                    ESP:
                                    <asp:CheckBox ID="ESPCheckBox" runat="server" Checked='<%# Bind("ESP") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    &nbsp;</td>
                                <td>
                                    &nbsp;</td>
                            </tr>
                        </table>
                        <br />
                        <br />
                        searched_user:
                        <asp:TextBox ID="searched_userTextBox" runat="server" 
                            Text='<%# Bind("searched_user") %>' />
                        <br />
                        model_by_user:
                        <asp:TextBox ID="model_by_userTextBox" runat="server" 
                            Text='<%# Bind("model_by_user") %>' />
                        <br />
                        <br />
                        engine_power:
                        <asp:TextBox ID="engine_powerTextBox" runat="server" 
                            Text='<%# Bind("engine_power") %>' />
                        <br />
                        first_reg_date:
                        <asp:TextBox ID="first_reg_dateTextBox" runat="server" 
                            Text='<%# Bind("first_reg_date") %>' />
                        <br />
                        millage_km:
                        <asp:TextBox ID="millage_kmTextBox" runat="server" 
                            Text='<%# Bind("millage_km") %>' />
                        <br />
                        fuel_type: <br />
                        gearbox: <br />
                        <br />
                        country_code:
                        <asp:TextBox ID="country_codeTextBox" runat="server" 
                            Text='<%# Bind("country_code") %>' />
                        <br />
                        location_city: <br />
                        climate_control:
                        <asp:TextBox ID="climate_controlTextBox" runat="server" 
                            Text='<%# Bind("climate_control") %>' />
                        <br />
                        seat_count: <br />
                        color: <br />
                        door_count: <br />
                        <br />
                        user_comments:
                        <asp:TextBox ID="user_commentsTextBox" runat="server" 
                            Text='<%# Bind("user_comments") %>' />
                        <br />
                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 
                            CommandName="Insert" Text="Insert" />
                        &nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server" 
                            CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                    </EditItemTemplate>
         
                </asp:FormView>
                <br />
                <br />
    <asp:DataList ID="DataList1" runat="server" DataKeyField="id" 
        DataSourceID="SqlDataSourceSearch_result" RepeatDirection="Horizontal" 
        GridLines="Both" RepeatColumns="1" Width="787px">
        <ItemTemplate>
            <table class="style1" style="color: #6600FF">
                <tr>
                    <td class="style3">
                        Make:
                        <asp:Label ID="make_nameLabel" runat="server" Text='<%# Eval("make_name") %>' />
                        <br />
                        Model:
                        <asp:Label ID="Expr1Label" runat="server" Text='<%# Eval("modelname") %>' />
                        <br />
                        <asp:Label ID="model_by_userLabel" runat="server" 
                            Text='<%# Eval("model_by_user") %>' />
                        <br />
                        Type:
                        <asp:Label ID="car_typeLabel" runat="server" 
                            Text='<%# Eval("vehicletype") %>' />
                        <asp:Image ID="Image1" runat="server" CssClass="style4" Height="130px" 
                            ImageUrl='<%# "UploadImages/"+ Eval("id") + "_001.jpg" %>' Width="116px" />
                        <br />
                        Power:
                        <asp:Label ID="engine_powerLabel" runat="server" 
                            Text='<%# Eval("engine_power") %>' />
                        <br />
                        Fierst Registration Date:
                        <asp:Label ID="first_reg_dateLabel" runat="server" 
                            Text='<%# Eval("first_reg_date") %>' />
                        <br />
                        Millage (KM):
                        <asp:Label ID="millage_kmLabel" runat="server" 
                            Text='<%# Eval("millage_km") %>' />
                        <br />
                        Fuel Type:
                        <asp:Label ID="fuel_typeLabel" runat="server" Text='<%# Eval("fuel_type") %>' />
                        <br />
                        Gearbox:
                        <asp:Label ID="gearboxLabel" runat="server" Text='<%# Eval("gearbox") %>' />
                        <br />
                        Price:
                        <asp:Label ID="priceLabel" runat="server" Text='<%# Eval("price") %>' />
                        <br />
                        Country :
                        <asp:Label ID="country_codeLabel" runat="server" 
                            Text='<%# Eval("modelname") %>' />
                        <br />
                        City:
                        <asp:Label ID="location_cityLabel" runat="server" 
                            Text='<%# Eval("location_city") %>' />
                        <br />
                        Clima:
                        <asp:Label ID="climate_controlLabel" runat="server" 
                            Text='<%# Eval("climate_control") %>' />
                        <br />
                        Seats:
                        <asp:Label ID="seat_countLabel" runat="server" 
                            Text='<%# Eval("seat_count") %>' />
                        <br />
                        Color:
                        <asp:Label ID="colorLabel" runat="server" Text='<%# Eval("color") %>' />
                        <br />
                        Doors:
                        <asp:Label ID="door_countLabel" runat="server" 
                            Text='<%# Eval("door_count") %>' />
                    </td>
                    <td>
                        &nbsp;</td>
                </tr>
                <tr>
                    <td class="style3">
                        Auxiliary heating:
                        <asp:Label ID="Auxiliary_heatingLabel" runat="server" 
                            Text='<%# (Boolean.Parse(Eval("Auxiliary_heating").ToString())) ? "Yes" : "No"   %>' />
                        <br />
                        Central locking:
                        <asp:Label ID="Central_lockingLabel" runat="server" 
                            Text='<%#  (Boolean.Parse(Eval("Central_locking").ToString())) ? "Yes" : "No"   %>' />
                        <br />
                        Cruise control:
                        <asp:Label ID="Cruise_controlLabel" runat="server" 
                            Text='<%# (Boolean.Parse(Eval("Cruise_control").ToString())) ? "Yes" : "No" %>' />
                        <br />
                        Electric heated:
                        <asp:Label ID="Electric_heatedLabel" runat="server" 
                            Text='<%# (Boolean.Parse(Eval("Electric_heated").ToString())) ? "Yes" : "No"  %>' />
                        <br />
                        Electric windows:
                        <asp:Label ID="Electric_windowsLabel" runat="server" 
                            Text='<%# (Boolean.Parse(Eval("Electric_windows").ToString())) ? "Yes" : "No"  %>' />
                        <br />
                        Leather seats:
                        <asp:Label ID="Leather_seatsLabel" runat="server" 
                            Text='<%# (Boolean.Parse(Eval("Leather_seats").ToString())) ? "Yes" : "No"  %>' />
                        <br />
                        Parking sensors:
                        <asp:Label ID="Parking_sensorsLabel" runat="server" 
                            Text='<%# (Boolean.Parse(Eval("Parking_sensors").ToString())) ? "Yes" : "No" %>' />
                    </td>
                    <td>
                        Power Steering:
                        <asp:Label ID="Power_SteeringLabel" runat="server" 
                            Text='<%# (Boolean.Parse(Eval("Power_Steering").ToString())) ? "Yes" : "No" %>' />
                        <br />
                        Sunroof:
                        <asp:Label ID="SunroofLabel" runat="server" Text='<%# (Boolean.Parse(Eval("Sunroof").ToString())) ? "Yes" : "No" %>' />
                        <br />
                        Four wheel drive:
                        <asp:Label ID="Four_wheel_driveLabel" runat="server" 
                            Text='<%# (Boolean.Parse(Eval("Four_wheel_drive").ToString())) ? "Yes" : "No" %>' />
                        <br />
                        Immobilizer:
                        <asp:Label ID="ImmobilizerLabel" runat="server" 
                            Text='<%# (Boolean.Parse(Eval("Immobilizer").ToString())) ? "Yes" : "No" %>' />
                        <br />
                        Xenon headlights:
                        <asp:Label ID="Xenon_headlightsLabel" runat="server" 
                            Text='<%# (Boolean.Parse(Eval("Xenon_headlights").ToString())) ? "Yes" : "No" %>' />
                        <br />
                        ABS:
                        <asp:Label ID="ABSLabel" runat="server" Text='<%# (Boolean.Parse(Eval("ABS").ToString())) ? "Yes" : "No" %>' />
                        <br />
                        ESP:
                        <asp:Label ID="ESPLabel" runat="server" Text='<%# (Boolean.Parse(Eval("ESP").ToString())) ? "Yes" : "No" %>' />
                    </td>
                </tr>
            </table>
            <br />
            id:
            <asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
            <br />
            user_comments:
            <asp:Label ID="user_commentsLabel" runat="server" 
                Text='<%# Eval("user_comments") %>' />
            <br />
            <br />
            <br />
        </ItemTemplate>
    </asp:DataList>
            </td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
        </tr>
    </table>
</asp:Content>
